<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<title>AbstractTestCase xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<pre>

<a name="1" href="#1">1</a>   <em class="jxr_comment">/*</em>
<a name="2" href="#2">2</a>   <em class="jxr_comment"> *    Copyright 2009-2010 The iBaGuice Team</em>
<a name="3" href="#3">3</a>   <em class="jxr_comment"> *</em>
<a name="4" href="#4">4</a>   <em class="jxr_comment"> *    Licensed under the Apache License, Version 2.0 (the "License");</em>
<a name="5" href="#5">5</a>   <em class="jxr_comment"> *    you may not use this file except in compliance with the License.</em>
<a name="6" href="#6">6</a>   <em class="jxr_comment"> *    You may obtain a copy of the License at</em>
<a name="7" href="#7">7</a>   <em class="jxr_comment"> *</em>
<a name="8" href="#8">8</a>   <em class="jxr_comment"> *       <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
<a name="9" href="#9">9</a>   <em class="jxr_comment"> *</em>
<a name="10" href="#10">10</a>  <em class="jxr_comment"> *    Unless required by applicable law or agreed to in writing, software</em>
<a name="11" href="#11">11</a>  <em class="jxr_comment"> *    distributed under the License is distributed on an "AS IS" BASIS,</em>
<a name="12" href="#12">12</a>  <em class="jxr_comment"> *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
<a name="13" href="#13">13</a>  <em class="jxr_comment"> *    See the License for the specific language governing permissions and</em>
<a name="14" href="#14">14</a>  <em class="jxr_comment"> *    limitations under the License.</em>
<a name="15" href="#15">15</a>  <em class="jxr_comment"> */</em>
<a name="16" href="#16">16</a>  <strong class="jxr_keyword">package</strong> com.google.code.ibaguice.samples;
<a name="17" href="#17">17</a>  
<a name="18" href="#18">18</a>  <strong class="jxr_keyword">import</strong> java.io.File;
<a name="19" href="#19">19</a>  <strong class="jxr_keyword">import</strong> java.io.StringReader;
<a name="20" href="#20">20</a>  <strong class="jxr_keyword">import</strong> java.util.List;
<a name="21" href="#21">21</a>  <strong class="jxr_keyword">import</strong> java.util.Properties;
<a name="22" href="#22">22</a>  
<a name="23" href="#23">23</a>  <strong class="jxr_keyword">import</strong> javax.sql.DataSource;
<a name="24" href="#24">24</a>  
<a name="25" href="#25">25</a>  <strong class="jxr_keyword">import</strong> lombok.Setter;
<a name="26" href="#26">26</a>  
<a name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> org.apache.ibatis.jdbc.ScriptRunner;
<a name="28" href="#28">28</a>  <strong class="jxr_keyword">import</strong> org.testng.annotations.BeforeClass;
<a name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> org.testng.annotations.Test;
<a name="30" href="#30">30</a>  
<a name="31" href="#31">31</a>  <strong class="jxr_keyword">import</strong> com.google.code.ibaguice.core.SqlSessionFactoryModule;
<a name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> com.google.code.ibaguice.core.datasource.PooledDataSourceProvider;
<a name="33" href="#33">33</a>  <strong class="jxr_keyword">import</strong> com.google.code.ibaguice.dao.TransactionalModule;
<a name="34" href="#34">34</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Binder;
<a name="35" href="#35">35</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Guice;
<a name="36" href="#36">36</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Inject;
<a name="37" href="#37">37</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Injector;
<a name="38" href="#38">38</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Module;
<a name="39" href="#39">39</a>  <strong class="jxr_keyword">import</strong> com.google.inject.Provider;
<a name="40" href="#40">40</a>  <strong class="jxr_keyword">import</strong> com.google.inject.name.Names;
<a name="41" href="#41">41</a>  
<a name="42" href="#42">42</a>  <em class="jxr_javadoccomment">/**</em>
<a name="43" href="#43">43</a>  <em class="jxr_javadoccomment"> * </em>
<a name="44" href="#44">44</a>  <em class="jxr_javadoccomment"> *</em>
<a name="45" href="#45">45</a>  <em class="jxr_javadoccomment"> * @author Simone Tripodi</em>
<a name="46" href="#46">46</a>  <em class="jxr_javadoccomment"> * @version $Id: AbstractTestCase.html 1839 2010-02-10 22:44:21Z simone.tripodi $</em>
<a name="47" href="#47">47</a>  <em class="jxr_javadoccomment"> */</em>
<a name="48" href="#48">48</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">abstract</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../com/google/code/ibaguice/samples/AbstractTestCase.html">AbstractTestCase</a> {
<a name="49" href="#49">49</a>  
<a name="50" href="#50">50</a>      @Inject
<a name="51" href="#51">51</a>      @Setter
<a name="52" href="#52">52</a>      <strong class="jxr_keyword">private</strong> ContactDao contactDao;
<a name="53" href="#53">53</a>  
<a name="54" href="#54">54</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> Contact contact = <strong class="jxr_keyword">new</strong> Contact();
<a name="55" href="#55">55</a>  
<a name="56" href="#56">56</a>      <strong class="jxr_keyword">protected</strong> Contact getContact() {
<a name="57" href="#57">57</a>          <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">this</strong>.contact;
<a name="58" href="#58">58</a>      }
<a name="59" href="#59">59</a>  
<a name="60" href="#60">60</a>      @BeforeClass
<a name="61" href="#61">61</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setUp() <strong class="jxr_keyword">throws</strong> Exception {
<a name="62" href="#62">62</a>          <strong class="jxr_keyword">this</strong>.contact.setFirstName(<span class="jxr_string">"Simone"</span>);
<a name="63" href="#63">63</a>          <strong class="jxr_keyword">this</strong>.contact.setLastName(<span class="jxr_string">"Tripodi"</span>);
<a name="64" href="#64">64</a>  
<a name="65" href="#65">65</a>          <em class="jxr_comment">// db URL setup</em>
<a name="66" href="#66">66</a>          File tmp = File.createTempFile(<span class="jxr_string">"dbTEST"</span>, <span class="jxr_string">".dat"</span>);
<a name="67" href="#67">67</a>          tmp.delete();
<a name="68" href="#68">68</a>          <strong class="jxr_keyword">final</strong> String connectionURL = <span class="jxr_string">"jdbc:derby:"</span>
<a name="69" href="#69">69</a>              + tmp.getAbsolutePath()
<a name="70" href="#70">70</a>              + <span class="jxr_string">";create=true"</span>;
<a name="71" href="#71">71</a>  
<a name="72" href="#72">72</a>          <strong class="jxr_keyword">final</strong> Properties ibatisProperties = <strong class="jxr_keyword">new</strong> Properties();
<a name="73" href="#73">73</a>          ibatisProperties.setProperty(<span class="jxr_string">"ibatis.environment.id"</span>, <span class="jxr_string">"test"</span>);
<a name="74" href="#74">74</a>          ibatisProperties.setProperty(<span class="jxr_string">"JDBC.driver"</span>, <span class="jxr_string">"org.apache.derby.jdbc.EmbeddedDriver"</span>);
<a name="75" href="#75">75</a>          ibatisProperties.setProperty(<span class="jxr_string">"JDBC.url"</span>, connectionURL);
<a name="76" href="#76">76</a>          ibatisProperties.setProperty(<span class="jxr_string">"JDBC.username"</span>, <span class="jxr_string">""</span>);
<a name="77" href="#77">77</a>          ibatisProperties.setProperty(<span class="jxr_string">"JDBC.password"</span>, <span class="jxr_string">""</span>);
<a name="78" href="#78">78</a>          ibatisProperties.setProperty(<span class="jxr_string">"JDBC.autoCommit"</span>, <span class="jxr_string">"true"</span>);
<a name="79" href="#79">79</a>  
<a name="80" href="#80">80</a>          <em class="jxr_comment">// bindings</em>
<a name="81" href="#81">81</a>          SqlSessionFactoryModule ibatisModule = <strong class="jxr_keyword">new</strong> SqlSessionFactoryModule(<strong class="jxr_keyword">this</strong>.getDataSourceProviderClass());
<a name="82" href="#82">82</a>  
<a name="83" href="#83">83</a>          ibatisModule.addSimpleAliases(Contact.<strong class="jxr_keyword">class</strong>);
<a name="84" href="#84">84</a>          ibatisModule.setMapperClasses(getMapperClass());
<a name="85" href="#85">85</a>  
<a name="86" href="#86">86</a>          Injector injector = Guice.createInjector(ibatisModule,
<a name="87" href="#87">87</a>                  <strong class="jxr_keyword">new</strong> TransactionalModule(),
<a name="88" href="#88">88</a>                  <strong class="jxr_keyword">new</strong> Module() {
<a name="89" href="#89">89</a>                      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> configure(Binder binder) {
<a name="90" href="#90">90</a>                          binder.bind(ContactDao.<strong class="jxr_keyword">class</strong>).to(getDaoClass()).asEagerSingleton();
<a name="91" href="#91">91</a>                          Names.bindProperties(binder, ibatisProperties);
<a name="92" href="#92">92</a>                          addAuxBinds(binder);
<a name="93" href="#93">93</a>                      }
<a name="94" href="#94">94</a>                  });
<a name="95" href="#95">95</a>  
<a name="96" href="#96">96</a>          <em class="jxr_comment">// prepare the test db</em>
<a name="97" href="#97">97</a>          DataSource dataSource = injector.getInstance(DataSource.<strong class="jxr_keyword">class</strong>);
<a name="98" href="#98">98</a>          ScriptRunner runner = <strong class="jxr_keyword">new</strong> ScriptRunner(dataSource.getConnection());
<a name="99" href="#99">99</a>          runner.setAutoCommit(<strong class="jxr_keyword">true</strong>);
<a name="100" href="#100">100</a>         runner.setStopOnError(<strong class="jxr_keyword">true</strong>);
<a name="101" href="#101">101</a>         runner.runScript(<strong class="jxr_keyword">new</strong> StringReader(
<a name="102" href="#102">102</a>                 <span class="jxr_string">"CREATE TABLE contact (id INT NOT NULL PRIMARY KEY GENERATED "</span>
<a name="103" href="#103">103</a>                 + <span class="jxr_string">"ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), first_name "</span>
<a name="104" href="#104">104</a>                 + <span class="jxr_string">"VARCHAR(20) NOT NULL, last_name VARCHAR(20) NOT NULL);"</span>));
<a name="105" href="#105">105</a>         runner.closeConnection();
<a name="106" href="#106">106</a> 
<a name="107" href="#107">107</a>         injector.injectMembers(<strong class="jxr_keyword">this</strong>);
<a name="108" href="#108">108</a>     }
<a name="109" href="#109">109</a> 
<a name="110" href="#110">110</a>     @Test
<a name="111" href="#111">111</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> insertContact() <strong class="jxr_keyword">throws</strong> Exception {
<a name="112" href="#112">112</a>         <strong class="jxr_keyword">this</strong>.contactDao.insert(<strong class="jxr_keyword">this</strong>.getContact());
<a name="113" href="#113">113</a>     }
<a name="114" href="#114">114</a> 
<a name="115" href="#115">115</a>     @Test(dependsOnMethods = { <span class="jxr_string">"insertContact"</span> })
<a name="116" href="#116">116</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> selectAllContacts() <strong class="jxr_keyword">throws</strong> Exception {
<a name="117" href="#117">117</a>         List&lt;Contact&gt; contacts = <strong class="jxr_keyword">this</strong>.contactDao.getAll();
<a name="118" href="#118">118</a>         assert contacts.size() &gt; 0 : <span class="jxr_string">"Expected not empty contact table"</span>;
<a name="119" href="#119">119</a>     }
<a name="120" href="#120">120</a> 
<a name="121" href="#121">121</a>     @Test(dependsOnMethods = <span class="jxr_string">"selectAllContacts"</span>)
<a name="122" href="#122">122</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> reSelectAllContacts() <strong class="jxr_keyword">throws</strong> Exception {
<a name="123" href="#123">123</a>         List&lt;Contact&gt; contacts = <strong class="jxr_keyword">this</strong>.contactDao.getAll();
<a name="124" href="#124">124</a>         assert contacts.size() &gt; 0 : <span class="jxr_string">"Expected not empty contact table"</span>;
<a name="125" href="#125">125</a>     }
<a name="126" href="#126">126</a> 
<a name="127" href="#127">127</a>     @Test(dependsOnMethods = <span class="jxr_string">"insertContact"</span>)
<a name="128" href="#128">128</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> selectContact() <strong class="jxr_keyword">throws</strong> Exception {
<a name="129" href="#129">129</a>         Contact contact = <strong class="jxr_keyword">this</strong>.contactDao.selectById(<strong class="jxr_keyword">this</strong>.getContact().getId());
<a name="130" href="#130">130</a>         assert contact != <strong class="jxr_keyword">null</strong> : <span class="jxr_string">"impossible to retrieve Contact with id '"</span>
<a name="131" href="#131">131</a>                                 + <strong class="jxr_keyword">this</strong>.getContact().getId()
<a name="132" href="#132">132</a>                                 + <span class="jxr_string">"'"</span>;
<a name="133" href="#133">133</a>         assert <strong class="jxr_keyword">this</strong>.getContact().equals(contact) : <span class="jxr_string">"Expected "</span>
<a name="134" href="#134">134</a>                                                 + <strong class="jxr_keyword">this</strong>.getContact()
<a name="135" href="#135">135</a>                                                 + <span class="jxr_string">" but found "</span>
<a name="136" href="#136">136</a>                                                 + contact;
<a name="137" href="#137">137</a>     }
<a name="138" href="#138">138</a> 
<a name="139" href="#139">139</a>     @Test
<a name="140" href="#140">140</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> catchSQLException() <strong class="jxr_keyword">throws</strong> Exception {
<a name="141" href="#141">141</a>         Contact contact = <strong class="jxr_keyword">this</strong>.contactDao.selectById(<strong class="jxr_keyword">this</strong>.getContact().getId());
<a name="142" href="#142">142</a>         assert contact != <strong class="jxr_keyword">null</strong> : <span class="jxr_string">"impossible to retrieve Contact with id '"</span>
<a name="143" href="#143">143</a>                                 + <strong class="jxr_keyword">this</strong>.getContact().getId()
<a name="144" href="#144">144</a>                                 + <span class="jxr_string">"'"</span>;
<a name="145" href="#145">145</a>         assert <strong class="jxr_keyword">this</strong>.getContact().equals(contact) : <span class="jxr_string">"Expected "</span>
<a name="146" href="#146">146</a>                                                 + <strong class="jxr_keyword">this</strong>.getContact()
<a name="147" href="#147">147</a>                                                 + <span class="jxr_string">" but found "</span>
<a name="148" href="#148">148</a>                                                 + contact;
<a name="149" href="#149">149</a>     }
<a name="150" href="#150">150</a> 
<a name="151" href="#151">151</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">abstract</strong> Class&lt;?&gt;[]  getMapperClass();
<a name="152" href="#152">152</a> 
<a name="153" href="#153">153</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">abstract</strong> Class&lt;? <strong class="jxr_keyword">extends</strong> ContactDao&gt; getDaoClass();
<a name="154" href="#154">154</a> 
<a name="155" href="#155">155</a>     <strong class="jxr_keyword">protected</strong> Class&lt;? <strong class="jxr_keyword">extends</strong> Provider&lt;DataSource&gt;&gt; getDataSourceProviderClass() {
<a name="156" href="#156">156</a>         <strong class="jxr_keyword">return</strong> PooledDataSourceProvider.<strong class="jxr_keyword">class</strong>;
<a name="157" href="#157">157</a>     }
<a name="158" href="#158">158</a> 
<a name="159" href="#159">159</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> addAuxBinds(Binder binder) {
<a name="160" href="#160">160</a>         <em class="jxr_comment">// do nothing</em>
<a name="161" href="#161">161</a>     }
<a name="162" href="#162">162</a> 
<a name="163" href="#163">163</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

